package com.cloudkinto.dto.order.inbound;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * @author long
 * @Description 常规入库单导入
 * @Date 2024/12/27 8:47
 */
@Data
public class NormalInboundImportDto {

    @Excel(name = "货柜号/跟踪号 Container No./Tracking", fixedIndex = 0, width = 30)
    private String trackingNumber;

    @Excel(name = "Warehouse Code/仓库代码", fixedIndex = 1, width = 30)
    private String warehouseCode;

    @Excel(name = "客户编码/Customer Code", fixedIndex = 2, width = 30)
    private String companyCode;

    @Excel(name = "到仓方式/Arrival Method", fixedIndex = 3, width = 30)
    private String arrivalMethod;

    @Excel(name = "Box Identification No./箱子标识号", fixedIndex = 4, width = 30)
    private String boxIdentificationNo;

    @Excel(name = "Package Qty/箱子数量", fixedIndex = 5, width = 30)
    private Integer boxTotalQty;

    @Excel(name = "SKU/SKU", fixedIndex = 6, width = 30)
    private String sku;

    @Excel(name = "Qty per Package/每箱数量", fixedIndex = 7, width = 30)
    private Integer perBoxQty;

    @Excel(name = "入库托盘数/Delivery Pallets", fixedIndex = 8, width = 30)
    private Integer palletsTotalQty;

    @Excel(name = "预计到达日期/EAD", importFormat = "yyyy-MM-dd", fixedIndex = 9, width = 30)
    private Date expectedDate;

    @Excel(name = "参考单号/Reference No.", fixedIndex = 10, width = 30)
    private String referenceNumber;

    @Excel(name = "备注/Note", fixedIndex = 11, width = 30)
    private String remark;

    @Excel(name = "Customized barcode/自定义箱条码", fixedIndex = 12, width = 30)
    private String customizeBarcode;

    @Excel(name = "Package Length/箱子长度 (cm/inch)", fixedIndex = 13, width = 30)
    private BigDecimal packageLength;

    @Excel(name = "Package Width/箱子宽度 (cm/inch)", fixedIndex = 14, width = 30)
    private BigDecimal packageWidth;

    @Excel(name = "Package Height/箱子高度 (cm/inch)", fixedIndex = 15, width = 30)
    private BigDecimal packageHeight;

    @Excel(name = "Package Weight/箱子重量 (kg/lb)", fixedIndex = 16, width = 30)
    private BigDecimal packageWeight;

    @Excel(name = "Unit (Metric/Imperial)/单位 (公制/英制)", fixedIndex = 17, width = 30)
    private String unit;
}
